# from typing import Counter
# import pymysql

# connet = pymysql.connect(host='192.168.0.14',port=3306,user='junfeng',passwd='Gzjunfeng888!',db='jf_python_db')
# cur = connet.cursor()
# sql = "INSERT INTO zt_data VALUES(null,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"%('纪王镇中梅巷8号','1625826000000','闵行区','广东省','白云区','华漕二部','广州市','None','吴佳','None','18701847220','幸福生活','NHEKAYHE黑莓','19924237889','0.0','19945689110','上海','上海市',"太和镇广州市白云区太和镇太和北路120号A3君丰集运中心(NNEKAYHE)室",'None','75485853455903','210709108605116104','021-60665320、021-34273296','None','None')
# # sql = "INSERT INTO zt_data VALUES(null,'纪王镇中梅巷8号','1625826000000','闵行区','广东省','白云区','华漕二部','广州市','None','吴佳','None','18701847220','幸福生活','NHEKAYHE黑莓','19924237889','0.0','19945689110','上海','上海市','太和镇广州市白云区太和镇太和北路120号A3君丰集运中心(NNEKAYHE)室','None','75485853455903','210709108605116104','021-60665320、021-34273296','None','None')"
# cur.execute(sql)
# connet.commit()


from typing import Counter
import pymysql

connet = pymysql.connect(host='192.168.0.14',port=3306,user='junfeng',passwd='Gzjunfeng888!',db='jf_python_db')
cur = connet.cursor()
# 增、删、改
sql= 'insert into zt_data(WAYBILL_CODE,kuaidi_type) values(null, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s); '

# 把sql语句传给游标执行
# 让游标execute去帮我拼接字符串
rows = cur.executemany(sql,[('男','123','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女','女')])
connet.commit()